package com.inc.admin.dao.biz;

import java.sql.JDBCType;
import java.util.Date;

import org.mybatis.dynamic.sql.SqlColumn;
import org.mybatis.dynamic.sql.SqlTable;

public final class BookSql {
    public static final Book book = new Book();

    /**编号*/
    public static final SqlColumn<Integer> id = book.id;

    /**书名*/
    public static final SqlColumn<String> name = book.name;

    /**作者*/
    public static final SqlColumn<String> author = book.author;

    /**分类*/
    public static final SqlColumn<Integer> classification = book.classification;

    /**数量*/
    public static final SqlColumn<Integer> count = book.count;

    public static final SqlColumn<Date> createTime = book.createTime;

    public static final class Book extends SqlTable {
        public final SqlColumn<Integer> id = column("id", JDBCType.INTEGER);

        public final SqlColumn<String> name = column("name", JDBCType.VARCHAR);

        public final SqlColumn<String> author = column("author", JDBCType.VARCHAR);

        public final SqlColumn<Integer> classification = column("classification", JDBCType.INTEGER);

        public final SqlColumn<Integer> count = column("count", JDBCType.INTEGER);

        public final SqlColumn<Date> createTime = column("create_time", JDBCType.DATE);

        public Book() {
            super("book");
        }
    }
}